<?php
namespace App\Services;
use App\Models\Appoint;

class AppointService {

   public static function getTotal($date) {
       $appoint_total = Appoint::where('date', $date)->where('status', 1)->count();
       $sign_in_total = Appoint::where('date', $date)->where('status', 2)->count();
       $sign_out_total = Appoint::where('date', $date)->where('status', 3)->count();
       return compact('appoint_total', 'sign_in_total', 'sign_out_total');
   }

}
